/**
 * Created by Administrator on 2015/9/8.
 */
var superM = {
    changeAdmitStatus:'update y_admit set status = ? where id = ?',
    queryAllAdmit:'select y_admit.id admitId,activeId,subject,y_active.status activeStatus,y_admit.status admitStatus,applyTime,name'+
                    ' from y_admit,y_userinfo,y_active '+
                    ' where y_userinfo.id=y_admit.userInfoId and y_active.id=y_admit.activeId and subject like ? order by y_admit.id desc',
    //��ѯ���޹صĿͻ�
    queryInvite:'select DISTINCT y_userinfo.id,name from y_userinfo,y_user where level>2 and '+
                 'y_userinfo.id=y_user.userInfoId and y_userinfo.id not in '+
                  '(select userInfoId from y_admit where activeId=?)'

};

module.exports = superM;